Model Tutorial Videos

The following tutorial videos cover Model topics.

Model Pro Overview

A walk-through demo on how to use data flow and data modeling with machine learning.

Connect to Microsoft OLAP or Tabular

A quick demo on how to connect to Microsoft Analysis Services (OLAP or Tabular).

Connect to a SQL Database

A quick demo on connecting to and querying an existing relational database.

Regular Hierarchies

Build SQL hierarchies in Model and navigate them in Discover.

Custom Maps

Create custom maps, based on your own custom shapes.

Data Statistics and Quality

Review statistics for the columns in a given table and take suggested actions, like adding time intelligence.

Python Data and Stock Charts

Learn how to download stock data in Model and use it to build charts in Discover.

Custom Column Calculations

Create or manipulate column values, or perform calculations on existing column values.

Unpivot Tool

Use the Unpivot tool to tabularize cross-tabbed data sets so they can be used in the analytics engine properly.

Extract SAP data with Glue

Use Datavard's Glue integration with Pyramid to extract raw SAP ERP data.

Buiding MS Tabular Models

Use Pyramid to design and build a Microsoft Tabular Model. Then use the model in Discover and Formulate.

Buiding Exasol Models

Use Pyramid to design and build an Exasol database and analytical model. Then use the model in Discover and Formulate.

Sample Data

Some of the videos use the "billings" Excel data set. You can download it here for your own testing.